SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.[vw_listadoalumnospiletaAnterior09-09-2008]
AS
SELECT     'Escuela 14' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41719781, 40954307, 41526236, 41719793, 41776803, 40954310, 39942086, 40954306, 40954309, 41719785, 40954302, 41660096, 
                      41522637, 41719782, 41719784, 41719614, 41660098, 41434859, 41522637)
UNION
SELECT     'Speluzzi' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (39696783, 38552258, 41719622, 38552263, 42010922, 38552261, 41526287, 38552254, 40954145, 38552259, 38552255, 40954175, 
                      41036833, 38552257, 41094555)
UNION
SELECT     'Escuela 26' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41831207, 40610999, 41416767, 41416782, 41416798, 41719660, 41185783, 41220823, 41642963, 41036602, 40611518, 41431945, 
                      41831289, 40610940, 41549836, 41476433, 41476332, 39944066, 41831261, 41526275, 41416714, 41476365, 41476341, 39943498, 41776714, 
                      41526245)
UNION
SELECT     'Escuela 57' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41476347, 41776744, 41476353, 41773914, 41831254, 41185805, 41220533, 41776718, 41416768, 41719591, 41476379, 41476344, 
                      41642923, 39386539, 41719562, 41642234, 42016623, 41220597, 41526286, 41476310, 41776749, 41642942, 41476389, 41776737, 41831804, 
                      42016638, 41642584, 41036601, 41831778, 41831254)
UNION
SELECT     'Escuela 64' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (40610459, 41220520, 41220900, 40610975, 41185531, 41776788, 39384557, 41831223, 41831771, 41776751, 40610732, 40954194, 
                      40609818, 41831820, 41185823, 39055771, 42016877, 41185764, 41776787, 39942688, 40611990, 39932169, 40611921, 39932175, 41547965)
UNION
SELECT     'Escuela 161' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (42064096, 39942308, 40609806, 40609802, 40548048, 41719580, 40609807, 42164405, 41476404, 41476406, 41476403, 41476402, 
                      42584099, 41476407, 42041562)
UNION
SELECT     'Escuela 8' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41094877, 41416925, 40790733, 39696562, 41416780, 39696579, 40610022, 41719766, 41719772, 39943540, 41416927, 41526352, 
                      41094882, 41719768, 39696580, 41094883, 41857354, 41094881, 41719767, 41719778, 40611686, 41719774, 41094878, 41719780, 41037145, 
                      41719613, 41526360, 41416928, 39942347, 41719776, 41083479, 41642973, 10690478, 41416643, 40611988, 12061267, 21573329, 17601281, 
                      12818510, 40610478, 41416684, 41416780, 41719479)
UNION
SELECT     'Escuela 237' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41036796, 41831272, 42167485, 38808470, 39943841, 41416731, 41220531, 40609845, 40611481, 39931347, 38039650, 39932226, 
                      39931359, 41476374, 40610439, 41094702, 41416726, 39386189, 39943495, 41220561, 41831826, 41642261, 40954122, 40610036, 40609118, 
                      41476330, 41642305, 40611422)
UNION
SELECT     'Escuela 241' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (39931290, 41220532, 41036281, 41476308, 41642303, 39932165, 42016684, 41416727, 41036827, 41203570, 42127981, 40556317, 
                      41719685, 41789685, 44120245, 40611691, 39697573, 41776731, 40272346, 41642255, 41476385, 41203570, 40954189)
UNION
SELECT     'Escuela 237' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41642275, 41831298, 41526298, 39943563, 40473456, 39941217, 39696837, 42016665, 39941267, 39931576, 41831209, 41416752, 
                      40611987, 39941208, 39941277, 41476329, 41776774, 41642241, 41719634, 41526266, 41831228, 41220511, 41831235, 41094586, 40610421, 
                      41561748, 41185842, 41831297, 41561748)
UNION
SELECT     'Escuela 241' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220556, 40954139, 40611367, 39488919, 41642250, 41416729, 41130560, 41831274, 42016654, 43045763, 41285299, 41476327, 
                      41526294, 41094613, 41719565, 42016674, 41719681, 41642941, 41416701, 41094693, 40002823, 40613367)
UNION
SELECT     'Escuela 259' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (42016886, 39943842, 41776753, 41776753, 42105662, 41220587, 40610411, 40609202, 39697908, 41416706, 41185600, 41476360, 
                      41526252, 39932124, 41094746, 41476388, 41776759, 41526208, 41719663, 42016647, 41831269, 42105648, 39932090, 39944065, 41526235, 
                      41642954)
UNION
SELECT     'Escuela Los Caldenes' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41917824, 41642724, 42016637, 41776710, 41526201, 41719604, 41896952, 41185788, 41719578, 41896952, 42011593, 41719606, 
                      42016648, 41185843)
UNION
SELECT     'Escuela 14' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (37086635, 40610476, 39942079)
UNION
SELECT     'Nuestra Señora de Lujan' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41719556, 41416792, 41776779, 41416723, 41185786, 41094678, 41220521, 41831243, 41185848, 41416758, 41220842, 41094652, 
                      41776722, 41185837, 41776794, 41526293, 41642927, 41476363, 41642949, 41642300, 41642260, 41642246, 41185795)
UNION
SELECT     'Escuela 216' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41642304, 41831230, 39943545, 41874930, 41526223, 41476396, 5671789, 41185822, 41831799, 40611426, 41220517, 41476368, 
                      41476325, 41416705, 41642277)
UNION
SELECT     'Escuela 259' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220587, 41719590, 41094746, 41526235, 41220516, 41642291, 40609848, 41719552, 41719663, 40611437, 41476361, 41776760, 
                      41476360, 41526218, 39697908, 41476388, 41776759, 41642954)
UNION
SELECT     'Escuela 84' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41642285, 41220515, 41476303, 41719564, 40670982, 39875390)
UNION
SELECT     'Escuela 66' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (42016669, 41526295, 41687718, 41185581, 41831784)
UNION
SELECT     'Escuela 12' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41094725, 40954199, 41185599, 39931326, 41776769, 40610987, 40348514, 41220595, 40609847, 41185511, 41719522, 39931261, 
                      41642222, 42635743, 41719682, 39386351, 41220571, 41036839, 41526234, 41220512, 41526383, 37487521, 41220512)
UNION
SELECT     'Escuela 111' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41719609, 40609805, 41776735, 41526411, 41858622, 41719650, 41220598, 41185784, 41831203, 42157505, 41642253, 41476395, 
                      41333814, 41642254, 41476337, 41416717, 41526272, 42016652, 41719639, 41872754, 42016636, 42016635, 41185831, 41416734, 41776703, 
                      41831791, 41220566, 41416800, 41719576, 39943527, 41642245, 41416709, 41416708, 42016652, 41827754, 41642254, 41858622)
UNION
SELECT     'Escuela 111' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41526227, 41398264, 41642926, 42183630, 41476326, 41526300, 41416709, 41831229, 41476371, 40110726, 41476392, 41776771, 
                      41416773, 41642267, 41831828, 41526217, 41831822, 41831825, 41831262, 41719674, 41776716, 42016633, 41094866, 41526136, 41094730, 
                      41220576, 41642319, 41526285, 41416708)
UNION
SELECT     'Escuela Santa Ines' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220562, 41719620, 41642262, 41719629, 42016690, 41719671, 42016628, 41642936, 41831785, 41476393, 41185817, 40609773, 
                      41526239, 41526260, 41559642, 41416703, 41416730, 41776755, 41185824, 41559647, 41416703)
UNION
SELECT     'Escuela 233' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41441509, 41719581, 41642056, 40220824, 41719687, 40612100)
UNION
SELECT     'Escuela 49' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220549, 41719696, 43289191, 41036609, 42105643, 41220821, 39385509, 41220544, 42164052)
UNION
SELECT     'Speluzzi' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (43299365, 43299368, 44806030, 44806049, 44342368, 43299367, 43299373, 43299372, 44120288, 43299366, 43299370, 44342348)
UNION
SELECT     'Escuela Especial 6' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (34889328, 37397453, 37397426, 40610020, 38796409, 40610020, 39696545, 37519205)
UNION
SELECT     'Escuela 222' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41776690, 41642914, 41719550, 41220864, 41642915, 41526494, 41037006, 41775109, 41220836, 41642908, 41776693, 41776692, 
                      41220835, 41418020, 41526493, 40944105, 41776699, 41037003, 41036912, 41220834, 41116724, 41776697, 41831654, 40610145, 41220847, 
                      41220839, 41776682, 39384428, 41776673, 40071634, 41831959, 41831665, 41036990, 41642905, 40642918, 41037013, 41831961)
UNION
SELECT     'Escuela 249' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220849, 41220838, 41037171, 41776687, 41031666, 41220844, 41526499, 41642901, 41220837, 41642910, 41831662, 41776696, 
                      41220841, 39289354, 41522619, 40610159, 41526408, 41036994, 41776672, 41036993, 39944045, 41036989, 41831670, 40610169, 41776695, 
                      41831655, 41831666, 40610142, 39944046, 41642680, 40019809)
UNION
SELECT     'Escuela 34' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (39941328, 41220832, 41776681, 41526496, 41220870, 41037020, 41036899, 41037007, 41037015, 41036914, 41220851, 41642904, 
                      41642913, 41526436, 41776689, 41220843, 41037012, 41831957, 41831653, 41642906, 41642911, 41776677, 40799220, 41220831, 41642919, 
                      41831963, 42028376, 41642902, 41776684)
UNION
SELECT     'Escuela Especial Nº 7' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (38161997, 39384421, 39941316, 43451359, 41831659, 38795974, 39054804, 36747735, 38036780)
UNION
SELECT     'Escuela 53' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220579, 41526363, 40954182, 41316312, 40611109, 41526361, 40611107, 41526367, 41526213, 40611110, 41036837, 41526364, 
                      41526368, 41526362)
UNION
SELECT     'Escuela 259' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41185765)
UNION
SELECT     'Escuela 66' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41831099,40609255)
UNION
SELECT     'Escuela Lujan' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41719643)
UNION
SELECT     'Escuela 241' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41642233)
UNION
SELECT     'Escuela 57' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41242298,41719607)
UNION
SELECT     'Escuela 216' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (5671789)
UNION
SELECT     'Escuela 26' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41036826)
UNION
SELECT     'Escuela  de Vertiz' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (41220827,
41719894,
40610914,
40610917,
39386970,
40610918,	
41526271,
41526135,
40610919,
41220643,
40610920,
41185525,
41220825,
40610911,
40822453
)
UNION
SELECT     'Escuela 26' AS hoja, idalumno, Apellidos, Nombres, documento, fechanacimiento, calle, numero
FROM         tb_alumnos
WHERE     documento IN (
39942999,
38808343,
41526388,
39055218,
39943489,
39932104,
39944076,
39385800,
39597149,
40610406)


GO
EXEC sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1[50] 2[25] 3) )"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1 [56] 4 [18] 2))"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      RowHeights = 220
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'USER', N'dbo', 'VIEW', N'vw_listadoalumnospiletaAnterior09-09-2008', NULL, NULL
GO
DECLARE @xp int
SELECT @xp=1
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'USER', N'dbo', 'VIEW', N'vw_listadoalumnospiletaAnterior09-09-2008', NULL, NULL
GO
